Data Warehousing Design Issues for ERP Systems
نویسنده
چکیده
As many organizations begin to go to production with large Enterprise Resource Planning (ERP) systems, the need for reporting and analysis on this information has grown. This paper will discuss the issues associated with designing a data warehouse for an ERP system. This paper is intended for people with a basic understanding of both data warehousing and ERP systems such as SAP AG, Oracle, PeopleSoft etc. This paper will cover the following topics. • Design issues for a data warehouse from ERP • Extraction using SAS/ACCESS® interface to SAP R/3 and SAS/ACCESS interface to Baan. • Management using SAS/Warehouse AdministratorTM • Loading issues for database design Attendees should leave this paper with a firm understanding of how to extract, transform, and load data from the major ERP systems into a SAS data warehouse.
منابع مشابه
An Exploratory Study of Data Quality Management Practices in the ERP Software Systems Context
Quality data are not only relevant for successful Data Warehousing or Business Intelligence applications; they are also a precondition for efficient and effective use of Enterprise Resource Planning (ERP) systems. ERP professionals in all kinds of businesses are concerned with data quality issues, as a survey, conducted by the Institute of Information Systems at the University of Bern, has show...
متن کاملBenefit Realisation Through ERP: The Re-Emergence of Data Warehousing
The need for an integrated enterprise-wide set of management information pronounced Data Warehousing the ‘hot topic’ of the early-to-mid 1990’s, however, it became unfashionable through the mid-to-late 1990s, with the approach of Y2K and with it the widespread implementation of ERP systems. However, in recent times, the re-emergence of Data Warehousing, to address the limitations and unrealised...
متن کاملMaking Sense of the Master Data Management (MDM) Concept: Old Wine in New Bottles or New Wine in Old Bottles?
This paper presents an insight into the emerging concept of Master Data Management (MDM) and highlights issues that both academics and business managers should consider to better understand the meaning of this ‘hot topic’. This critical reflection paper is forward looking and attempts to make sense of the MDM concept and highlight the issues associated with implementation. We argue that both th...
متن کاملTowards a model for evaluating organisational readiness for ERP and data warehousing projects
The need for an integrated enterprise-wide set of management information pronounced Data Warehousing the ‘hot topic’ of the early-to-mid 1990’s, however, it became unfashionable through the mid-to-late 1990s, with the approach of Y2K and the widespread implementation of ERP (Enterprise Resource Planning) systems. However, in recent times, the re-emergence of Data Warehousing, coupled with ERP i...
متن کاملTowards a model of organisational prerequisites for enterprise-wide systems integration: Examining ERP and data warehousing
Purpose – The need for an integrated enterprise-wide approach to management information pronounced data warehousing (DW) the “hot topic” of the early-to-mid-1990s. However, it became unfashionable in the late 1990s, with the widespread implementation of enterprise resource planning (ERP) systems. With ERP managers were led to believe that they would derive informational as well as operational b...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2000